﻿CREATE TABLE [dbo].[Bills] (
    [Id]                              NVARCHAR (100) NOT NULL,
    [Title]                           NVARCHAR (MAX) NOT NULL,
    [Date]                            DATETIME       NOT NULL,
    [Summary]                         NVARCHAR (MAX) NOT NULL,
    [IndexedContent]                  NVARCHAR (MAX) NOT NULL,
    [Number]                          NVARCHAR (MAX) NULL,
    [Status]                          NVARCHAR (MAX) NOT NULL,
    [LongTitle]                       NVARCHAR (MAX) NOT NULL,
    [FirstReadingWordLink]            NVARCHAR (MAX) NOT NULL,
    [FirstReadingHTMLLink]            NVARCHAR (MAX) NOT NULL,
    [Type]                            NVARCHAR (MAX) NOT NULL,
    [Portfolio]                       NVARCHAR (MAX) NULL,
    [Sponsor]                         NVARCHAR (MAX) NULL,
    [FirstReadingPDFLink]             NVARCHAR (MAX) NOT NULL,
    [AsPassedWordLink]                NVARCHAR (MAX) NOT NULL,
    [AsPassedHTMLLink]                NVARCHAR (MAX) NOT NULL,
    [AsPassedPDFLink]                 NVARCHAR (MAX) NOT NULL,
    [LastModified]                    DATETIME       NOT NULL,
    [ParlInfoBillHomeLink]            NVARCHAR (MAX) NOT NULL,
    [ProgressStages]                  NVARCHAR (MAX) NOT NULL,
    [OriginatingChamber]              NVARCHAR (MAX) NOT NULL,
    [ParliamentNumber]                INT            NOT NULL,
    [ProposedAmendmentsList]          NVARCHAR (MAX) NOT NULL,
    [FoundInFirstReading]             BIT            NULL,
    [FoundInAsPassed]                 BIT            NULL,
    [TitleFirstLetter]                NCHAR (1)      NOT NULL,
    [SponsorId]                       NVARCHAR (MAX) NULL,
    [GenericSearchResultBill_Bill_Id] NVARCHAR (100) NOT NULL
);









